-- @owner: songjing20
-- @date: 2024-7-12
-- @testpoint: connect_by_root后的列存在空格，执行connect by查询

--step1:创建表并插入数据;expect:成功
drop table if exists t_connectby_0035 cascade;
create table t_connectby_0035(x varchar2(10),y number,z number,a text);
insert into t_connectby_0035 values('A',1,null,' '),('B',2,1,' '),('C',3,1,' '),('D',4,2,' '),('E',5,3,' ') ,('F',6,4,' '),('G',7,4,' ');

--step2:执行connect by查询;expect:成功
select connect_by_root a from t_connectby_0035 start with x = 'A' connect by prior y=z;

--step3:删除表;expect:成功
drop table if exists t_connectby_0035 cascade;
